Skip to main content

Create Dataset Using noSQL

What is NoSQL?

  • A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. It is non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph.

What is MongoDB?

  • MongoDB is an open-source document database built on a horizontal scale-out architecture that uses a flexible schema for storing data.
info

To know how to create datasource using MongoDB for NoSQL Click here

  1. Refer this Link to know more about how to create dataset. (Refer till step No-3 for this example)

  2. Fill the Details as per below:

  • Datasource: No SQL
  • Source: admin_aiv

Docusaurus Slash Introduction

Note

To know more about terminology of General tab Click here

  1. In the Query box write code as given below:
    db.customers.find({country: “USA”})

Docusaurus Slash Introduction

  1. Go to Preview mode & see the country column. It will show the data of the USA as user written in Query.

    Docusaurus Slash Introduction

Note

To know more about terminology of Preview tab Click here

  1. Go to the General mode & give a name to the dataset “Customers_USA” & click on Submit button.

  2. Created Successfully message will pop up at the top of the screen.

  3. Go to the hamburger menu > Master Data > Dataset

  4. When the user clicks multiple times on the Last Updated column, created dataset ‘Customers_USA’ will appear at the top as shown below:

    Docusaurus Slash Introduction

  5. User needs to double click on that dataset if they want to edit that created dataset ‘Customers_USA”.

Note

Click here to know more about how to edit dataset.